DateTimeToSeconds (dateTime)

Basic and Crystal syntax.

Arguments

dateTime is a DateTime value.

Returns

Time value (in seconds)

Action

Evaluates the DateTime value and returns the number of seconds that have passed between 00:00:00 (12:00 midnight) and the specified time.

Examples

The following examples are applicable to both Basic and Crystal syntax:

DateTimeToSeconds(#11/01/1998 11:30:15 AM#)

Returns 41415.

Comments

Instead of using DateTimeToSeconds (dt), you can use:

DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (dt)))

The above expression does not use UFLs and can be more efficient.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com